CarrierStandardParcelSize

Entity Definition

Logical Name : CarrierStandardParcelSize
Physical Name : CO_CRR_STD_PRCL_SZ

Identifies, names and describes a pre-defined parcel package used to price shipping services. Different carriers offer different pre-specified package sizes (weight and cubic dimensions).

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
StandardParcelSizeID (PK) Token identifier for a CarrierStandardParcelSize entity type instance ID_STD_PRCL_SZ Identity integer
CarrierID (FK) A unique system assigned identifier for the Carrier. ID_CRR Identity integer Carrier(PA_CRR)
ParcelStandardSizeCode A carrier-specific code that designates a standard size and accompanying pricing for transporting a package. Examples: Federal Express 01 - FedEx Customer Packaging 02 - FedEx Pak 03 - FedEx Box 04 - FedEx Tube 08 - FedEx Packet (select markets) UPS 10 or 22 10kg or 22 lbs. box 25 or 55 25kg or 55 lbs. box US Postal Service FLT - Flat LTP or 06 - Priority mail letter pack LTR or 06 - Letter FSB - Priority Mail Small Flat Rate Box FRB - Priority Mail (Regular) Flat Rate Box IRG - Irregular Parcel Other carriers will have their own codes CD_PRCL_STD_SZ Code varchar(20)
GrossWeightQuantity The gross weight of the ShipmentContainer including merchandise plus the weight of the container itself QW_GS_WT_QTY Quantity DECIMAL(9,3)
DimensionalWeightQuantity Dimensional weight, also known as volumetric weight, is a pricing technique for commercial freight transport (including courier and postal services), which uses an estimated weight that is calculated from the length, width and height of a package. Shipping costs have historically been calculated on the basis of gross weight in kilograms or pounds. By charging only by weight, lightweight, low density packages become unprofitable for freight carriers due to the amount of space they take up in the truck/aircraft/ship in proportion to their actual weight. The concept of dimensional weight has been adopted by the transportation industry worldwide as a uniform means of establishing a minimum charge for the cubic space a package occupies. In fact, UPS[1] and Fedex[2] have recently announced that starting 2015, shipping charges on all shipments (air and ground) will be determined by greater of the actual weight and dimensional weight of a package. Prior to this announcement, dimensional weight charges were only applicable to packages of a specific size range. Dimensional weight is a calculation of a theoretical weight of a package. This theoretical weight is the weight of the package at a minimum density chosen by the freight carrier. If the package is below this minimum density, then the actual weight is irrelevant as the freight carrier will charge for the volume of the package as if it were of the chosen density (what the package would weigh at the minimum density). Furthermore, the volume used to calculate the dimensional weight may not be absolutely representative of the true volume of the package. The freight carrier will measure the longest dimension in each of the three axis (X, Y, Z) and use these measurements to determine the package volume. If the package is a right-angled rectangular box (cuboid), then this will be equal to the true volume of the package. However, if the package is of any other shape, then the calculation of volume will be more than the true volume of the package. Dimensional weight is also known as DIM weight, volumetric weight, or cubed weight. Freight carriers utilize the greater of the actual weight or dimensional weight to calculate shipping charges. Dimensional weight is calculated as (length � width � height) / (dimensional factor). Measurements can be made all in inches or all in centimeters, but the appropriate shipping factor must also be used. QW_DMNSNL_WT_QTY Quantity DECIMAL(9,3)
WeightQuantity The weight of the merchandise without the container. QW_WT_QTY Quantity DECIMAL(9,3)
Weight (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM_WT Code varchar(20) UnitOfMeasure(CO_UOM)
ContainerHeightQuantity The height of a container. Used to define dimensions for load configuration. QL_CNR_HT_QTY Quantity DECIMAL(9,3)
ContainerLengthQuantity The length of a container. Used to define dimensions for load configuration. QL_CNR_LNG_QTY Quantity DECIMAL(9,3)
ContainerWidthQuantity The width of a container. Used to define dimensions for load configuration. QL_CNR_WD_QTY Quantity DECIMAL(9,3)
Linear (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM_LNR Code varchar(20) UnitOfMeasure(CO_UOM)

Relationships

Parent Entity Verb Phrase Child Entity
UnitOfMeasure defines units of mass for CarrierStandardParcelSize
Carrier defines CarrierStandardParcelSize
UnitOfMeasure defines linear units for CarrierStandardParcelSize
CarrierStandardParcelSize standardizes dimensions for CustomerOrderShipmentContainer

No Logical Views for CarrierStandardParcelSize